﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="list.aspx.vb" Inherits="island.list" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
  <br />
<br />


 <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <p>
   
   </p>
    <p>
        
    </p>
  
        <asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDataSource1">
        <ItemTemplate>
        <a href ='list.aspx?TagName=<%#Eval("TagName")%>'>
         <%#Eval("TagName")%>
       </a> |
        </ItemTemplate>
        </asp:Repeater>
        <a href="list.aspx">show all</a>
       <br />
        <br />
         <br />


           <asp:Button ID="Button1" runat="server" Text="AddNew" PostBackUrl="~/addNewIsland.aspx" />
     <br />
    <br />
    <asp:ImageButton ID="ImageButton1" runat="server" Height="40px" 
        ImageUrl="~/Pictures/rss.jpg" style="margin-left: 0px" Width="73px" />
        <br />
         <br />
  


    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" cssclass="design"
         DataKeyNames="ID">
        <Columns>
            <asp:HyperLinkField DataNavigateUrlFields="Website" 
                DataNavigateUrlFormatString="{0}" DataTextField="IslandName" 
                HeaderText="IslandName" />
            <asp:HyperLinkField DataNavigateUrlFields="ID" 
                DataNavigateUrlFormatString="details.aspx?ID={0}" DataTextField="PhoneNumber" 
                HeaderText="PhoneNumber" />
            <asp:HyperLinkField DataNavigateUrlFields="Postcode" 
                DataNavigateUrlFormatString="http://maps.google.co.uk/maps?q={0}" 
                DataTextField="Postcode" HeaderText="Map" />
            <asp:BoundField DataField="MitchelinStars" HeaderText="MitchelinStars" 
                SortExpression="MitchelinStars" />
            <asp:ImageField DataImageUrlField="IslandPicture" HeaderText="Thumbnail">
                <ControlStyle Height="100px" Width="100px" />
            </asp:ImageField>
            <asp:BoundField DataField="IslandName" HeaderText="IslandName" 
                SortExpression="IslandName" />
        </Columns>
    </asp:GridView>
       <br />
        <br />
         <br />
 
    <asp:SqlDataSource ID="IslandDataSource" runat="server" 
        ConnectionString="<%$ ConnectionStrings:IslandConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:IslandConnectionString.ProviderName %>" 
        
            
            SelectCommand="SELECT [Postcode], [Website], [PhoneNumber], [MitchelinStars], [IslandPicture], [ID], [IslandName] FROM [tour]">
    </asp:SqlDataSource>
       <br />
        <br />
         <br />

    <asp:SqlDataSource ID="IslandDataSource0" runat="server" 
        ConnectionString="<%$ ConnectionStrings:IslandConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:IslandConnectionString.ProviderName %>" 
         SelectCommand="SELECT [IslandName], [TagName], [ID], [Postcode], [Website], [PhoneNumber], [Description], [IslandPicture], [MitchelinStars], [Location], [PlacestoVisit] FROM [TagIslandview] WHERE ([TagName] = ?)">
        <SelectParameters>
            <asp:QueryStringParameter DefaultValue="" Name="TagName" 
                QueryStringField="TagName" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
    <br />
  Display these kind of islands
  <br />
    
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:IslandConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:IslandConnectionString.ProviderName %>" 
            SelectCommand="SELECT [ID], [TagName] FROM [tag]"></asp:SqlDataSource>
        <br />
        <br />
         <br />
    <asp:TextBox ID="tb_ts" runat="server"></asp:TextBox>
   <br />
        <br />
         <br />
    <asp:Button ID="btn_search" runat="server" Text="Search" Width="70px" />

</asp:Content>
